package com.xxjqr.rbac.mapper;

import com.xxjqr.rbac.anno.PageQuery;
import com.xxjqr.rbac.entity.pojo.TbJob;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.xxjqr.rbac.entity.vo.JobVo;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 * 岗位表 Mapper 接口
 * </p>
 *
 * @author 丁昌江
 * @since 2021-03-02
 */
public interface TbJobMapper extends BaseMapper<TbJob> {

    @PageQuery
    List<JobVo> getJobs(String code, String name, Integer status);

    @Select("select id,name,code,sort,status,remarks,create_time from tb_job where is_delete = 0")
    List<JobVo> getJobList();
}
